Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	1325100
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	204.1 MiB
Average record size in memory	161.5 B

Variable types

Categorical	4
DateTime	1
Numeric	11

Alerts

`cusip_id` has a high cardinality: 1893 distinct values	High cardinality
`bond_sym_id` has a high cardinality: 1981 distinct values	High cardinality
`company_symbol` has a high cardinality: 520 distinct values	High cardinality
`rptd_pr` is highly overall correlated with `yld_pt`	High correlation
`yld_pt` is highly overall correlated with `rptd_pr`	High correlation
`offering_yield` is highly overall correlated with `coupon`	High correlation
`coupon` is highly overall correlated with `offering_yield`	High correlation
`offering_month` is highly overall correlated with `maturity_month`	High correlation
`maturity_month` is highly overall correlated with `offering_month`	High correlation
`principal_amt` is highly imbalanced (98.5%)	Imbalance
`yld_pt` is highly skewed (γ1 = 175.5750013)	Skewed
`offering_yield` is highly skewed (γ1 = 43.47418549)	Skewed
`cusip_id` is uniformly distributed	Uniform

Reproduction

Analysis started	2023-08-10 18:42:53.548349
Analysis finished	2023-08-10 18:43:36.685457
Duration	43.14 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

cusip_id
Categorical

HIGH CARDINALITY UNIFORM

Distinct	1893
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	20.2 MiB

00037BAB8	700
65339KBM1	700
655844BJ6	700
655664AT7	700
655664AS9	700
Other values (1888)	1321600

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	11925900
Distinct characters	34
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	00037BAB8
2nd row	00037BAB8
3rd row	00037BAB8
4th row	00037BAB8
5th row	00037BAB8

Common Values

Value	Count	Frequency (%)
00037BAB8	700	0.1%
65339KBM1	700	0.1%
655844BJ6	700	0.1%
655664AT7	700	0.1%
655664AS9	700	0.1%
65504LAP2	700	0.1%
65504LAN7	700	0.1%
655044AP0	700	0.1%
655044AH8	700	0.1%
654902AE5	700	0.1%
Other values (1883)	1318100	99.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00037bab8	700	0.1%
00206rcl4	700	0.1%
001055ap7	700	0.1%
001055aq5	700	0.1%
001546at7	700	0.1%
00164vac7	700	0.1%
00164vae3	700	0.1%
00185aad6	700	0.1%
00185aaf1	700	0.1%
00185aak0	700	0.1%
Other values (1883)	1318100	99.5%

Most occurring characters

Value	Count	Frequency (%)
0	1026900	8.6%
2	940800	7.9%
7	891100	7.5%
4	889000	7.5%
6	870100	7.3%
3	866600	7.3%
1	864500	7.2%
5	856800	7.2%
A	845600	7.1%
8	833700	7.0%
Other values (24)	3040800	25.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	8731100	73.2%
Uppercase Letter	3194800	26.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	845600	26.5%
B	355600	11.1%
C	208600	6.5%
D	151200	4.7%
E	112700	3.5%
H	103600	3.2%
F	100100	3.1%
N	100100	3.1%
X	98000	3.1%
J	97300	3.0%
Other values (14)	1022000	32.0%

Decimal Number

Value	Count	Frequency (%)
0	1026900	11.8%
2	940800	10.8%
7	891100	10.2%
4	889000	10.2%
6	870100	10.0%
3	866600	9.9%
1	864500	9.9%
5	856800	9.8%
8	833700	9.5%
9	691600	7.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	8731100	73.2%
Latin	3194800	26.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	845600	26.5%
B	355600	11.1%
C	208600	6.5%
D	151200	4.7%
E	112700	3.5%
H	103600	3.2%
F	100100	3.1%
N	100100	3.1%
X	98000	3.1%
J	97300	3.0%
Other values (14)	1022000	32.0%

Common

Value	Count	Frequency (%)
0	1026900	11.8%
2	940800	10.8%
7	891100	10.2%
4	889000	10.2%
6	870100	10.0%
3	866600	9.9%
1	864500	9.9%
5	856800	9.8%
8	833700	9.5%
9	691600	7.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11925900	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1026900	8.6%
2	940800	7.9%
7	891100	7.5%
4	889000	7.5%
6	870100	7.3%
3	866600	7.3%
1	864500	7.2%
5	856800	7.2%
A	845600	7.1%
8	833700	7.0%
Other values (24)	3040800	25.5%

trd_exctn_dt
Date

Distinct	1577
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	20.2 MiB

Minimum	2017-01-04 00:00:00
Maximum	2022-09-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

bond_sym_id
Categorical

Distinct	1981
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	20.2 MiB

ABB3852125	700
MUR3856177	700
NWL3865872	700
NTAP4547207	700
NTAP4131791	700
Other values (1976)	1321600

Length

Max length	12
Median length	10
Mean length	9.9765542
Min length	8

Characters and Unicode

Total characters	13219932
Distinct characters	36
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ABB3852125
2nd row	ABB3852125
3rd row	ABB3852125
4th row	ABB3852125
5th row	ABB3852125

Common Values

Value	Count	Frequency (%)
ABB3852125	700	0.1%
MUR3856177	700	0.1%
NWL3865872	700	0.1%
NTAP4547207	700	0.1%
NTAP4131791	700	0.1%
NTAP3940743	700	0.1%
CMCS3910950	700	0.1%
NFG4543079	700	0.1%
MYL4072753	700	0.1%
MUR4880676	700	0.1%
Other values (1971)	1318100	99.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
abb3852125	700	0.1%
are4459169	700	0.1%
acc4136081	700	0.1%
aep4563780	700	0.1%
aep4773531	700	0.1%
ael4507378	700	0.1%
axp4633129	700	0.1%
axp4662255	700	0.1%
axp4764026	700	0.1%
axp4764027	700	0.1%
Other values (1971)	1318100	99.5%

Most occurring characters

Value	Count	Frequency (%)
4	2066400	15.6%
3	993300	7.5%
8	844200	6.4%
6	840000	6.4%
0	786800	6.0%
2	778400	5.9%
5	768600	5.8%
1	758800	5.7%
9	755300	5.7%
7	683900	5.2%
Other values (26)	3944232	29.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	9275700	70.2%
Uppercase Letter	3944232	29.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	321354	8.1%
A	303906	7.7%
M	284451	7.2%
S	259563	6.6%
P	234284	5.9%
B	213910	5.4%
T	213324	5.4%
L	198984	5.0%
N	175470	4.4%
E	163368	4.1%
Other values (16)	1575618	39.9%

Decimal Number

Value	Count	Frequency (%)
4	2066400	22.3%
3	993300	10.7%
8	844200	9.1%
6	840000	9.1%
0	786800	8.5%
2	778400	8.4%
5	768600	8.3%
1	758800	8.2%
9	755300	8.1%
7	683900	7.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	9275700	70.2%
Latin	3944232	29.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	321354	8.1%
A	303906	7.7%
M	284451	7.2%
S	259563	6.6%
P	234284	5.9%
B	213910	5.4%
T	213324	5.4%
L	198984	5.0%
N	175470	4.4%
E	163368	4.1%
Other values (16)	1575618	39.9%

Common

Value	Count	Frequency (%)
4	2066400	22.3%
3	993300	10.7%
8	844200	9.1%
6	840000	9.1%
0	786800	8.5%
2	778400	8.4%
5	768600	8.3%
1	758800	8.2%
9	755300	8.1%
7	683900	7.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13219932	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
4	2066400	15.6%
3	993300	7.5%
8	844200	6.4%
6	840000	6.4%
0	786800	6.0%
2	778400	5.9%
5	768600	5.8%
1	758800	5.7%
9	755300	5.7%
7	683900	5.2%
Other values (26)	3944232	29.8%

company_symbol
Categorical

Distinct	520
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	20.2 MiB

AAPL	18900
C	16100
CMCS	16100
GM	16100
DUK	14700
Other values (515)	1243200

Length

Max length	5
Median length	3
Mean length	2.9765542
Min length	1

Characters and Unicode

Total characters	3944232
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ABB
2nd row	ABB
3rd row	ABB
4th row	ABB
5th row	ABB

Common Values

Value	Count	Frequency (%)
AAPL	18900	1.4%
C	16100	1.2%
CMCS	16100	1.2%
GM	16100	1.2%
DUK	14700	1.1%
BA	14700	1.1%
BP	14000	1.1%
CVS	14000	1.1%
F	12600	1.0%
UNH	12600	1.0%
Other values (510)	1175300	88.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
aapl	18900	1.4%
c	16100	1.2%
cmcs	16100	1.2%
gm	16100	1.2%
duk	14700	1.1%
ba	14700	1.1%
bp	14000	1.1%
cvs	14000	1.1%
f	12600	1.0%
unh	12600	1.0%
Other values (510)	1175300	88.7%

Most occurring characters

Value	Count	Frequency (%)
C	321354	8.1%
A	303906	7.7%
M	284451	7.2%
S	259563	6.6%
P	234284	5.9%
B	213910	5.4%
T	213324	5.4%
L	198984	5.0%
N	175470	4.4%
E	163368	4.1%
Other values (16)	1575618	39.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3944232	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	321354	8.1%
A	303906	7.7%
M	284451	7.2%
S	259563	6.6%
P	234284	5.9%
B	213910	5.4%
T	213324	5.4%
L	198984	5.0%
N	175470	4.4%
E	163368	4.1%
Other values (16)	1575618	39.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3944232	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	321354	8.1%
A	303906	7.7%
M	284451	7.2%
S	259563	6.6%
P	234284	5.9%
B	213910	5.4%
T	213324	5.4%
L	198984	5.0%
N	175470	4.4%
E	163368	4.1%
Other values (16)	1575618	39.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3944232	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	321354	8.1%
A	303906	7.7%
M	284451	7.2%
S	259563	6.6%
P	234284	5.9%
B	213910	5.4%
T	213324	5.4%
L	198984	5.0%
N	175470	4.4%
E	163368	4.1%
Other values (16)	1575618	39.9%

entrd_vol_qt
Real number (ℝ)

Distinct	18633
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1356446.6

Minimum	1
Maximum	5.83931 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.2 MiB

Quantile statistics

Minimum	1
5-th percentile	10000
Q1	54000
median	270000
Q3	1011000
95-th percentile	6000000
Maximum	5.83931 × 10⁸
Range	5.83931 × 10⁸
Interquartile range (IQR)	957000

Descriptive statistics

Standard deviation	3515981.9
Coefficient of variation (CV)	2.5920532
Kurtosis	799.35082
Mean	1356446.6
Median Absolute Deviation (MAD)	245000
Skewness	13.065426
Sum	1.7974275 × 10¹²
Variance	1.2362129 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100000	55837	4.2%
500000	55613	4.2%
1000000	51678	3.9%
50000	47090	3.6%
200000	39602	3.0%
25000	37691	2.8%
10000	33883	2.6%
2000000	30062	2.3%
250000	29652	2.2%
20000	24642	1.9%
Other values (18623)	919350	69.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
500	2	< 0.1%
1000	1022	0.1%
2000	8291	0.6%
2286	1	< 0.1%
3000	7352	0.6%
4000	6258	0.5%
5000	18526	1.4%
6000	5729	0.4%
7000	4736	0.4%

Value	Count	Frequency (%)
583931000	1	< 0.1%
265568000	1	< 0.1%
237000000	1	< 0.1%
223650000	1	< 0.1%
201825000	1	< 0.1%
201139000	1	< 0.1%
193200000	1	< 0.1%
182000000	1	< 0.1%
176695000	1	< 0.1%
173500000	1	< 0.1%

rptd_pr
Real number (ℝ)

Distinct	126514
Distinct (%)	9.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	104.32245

Minimum	1 × 10^-6
Maximum	142.646
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.2 MiB

Quantile statistics

Minimum	1 × 10^-6
5-th percentile	95.576
Q1	100.425
median	103.715
Q3	108.304
95-th percentile	115.24705
Maximum	142.646
Range	142.646
Interquartile range (IQR)	7.879

Descriptive statistics

Standard deviation	7.116482
Coefficient of variation (CV)	0.068216205
Kurtosis	15.901142
Mean	104.32245
Median Absolute Deviation (MAD)	3.708
Skewness	-1.3255251
Sum	1.3823768 × 10⁸
Variance	50.644316
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	1721	0.1%
101	1188	0.1%
102	1065	0.1%
100.5	994	0.1%
101.5	970	0.1%
99	954	0.1%
103	912	0.1%
99.5	901	0.1%
104	894	0.1%
101.25	892	0.1%
Other values (126504)	1314609	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1 × 10^-6	1	< 0.1%
0.625	1	< 0.1%
1	4	< 0.1%
1.1	1	< 0.1%
1.125	1	< 0.1%
1.151	1	< 0.1%
1.188	1	< 0.1%
1.25	1	< 0.1%
1.375	1	< 0.1%
1.47	1	< 0.1%

Value	Count	Frequency (%)
142.646	1	< 0.1%
142.29	1	< 0.1%
142.275	1	< 0.1%
142.044	1	< 0.1%
141.998	1	< 0.1%
141.897	1	< 0.1%
141.846	1	< 0.1%
141.813	1	< 0.1%
141.79	1	< 0.1%
141.75	1	< 0.1%

yld_pt
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1100043
Distinct (%)	83.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5137435

Minimum	0
Maximum	2292.1058
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	20.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0.36041385
Q1	1.2484038
median	2.2548945
Q3	3.3019775
95-th percentile	5.014431
Maximum	2292.1058
Range	2292.1058
Interquartile range (IQR)	2.0535737

Descriptive statistics

Standard deviation	4.2567184
Coefficient of variation (CV)	1.6933782
Kurtosis	71345.963
Mean	2.5137435
Median Absolute Deviation (MAD)	1.027356
Skewness	175.575
Sum	3330961.5
Variance	18.119652
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.25	14	< 0.1%
3	13	< 0.1%
0.15	11	< 0.1%
0.100001	10	< 0.1%
0.2	9	< 0.1%
0.953921	8	< 0.1%
0.6	8	< 0.1%
1.862988	8	< 0.1%
0.23	7	< 0.1%
2.332995	7	< 0.1%
Other values (1100033)	1325005	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
0.000295	1	< 0.1%
0.000297	1	< 0.1%
0.000306	1	< 0.1%
0.000394	1	< 0.1%
0.000407	1	< 0.1%
0.000516	1	< 0.1%
0.000724	1	< 0.1%
0.000779	1	< 0.1%
0.000798	1	< 0.1%

Value	Count	Frequency (%)
2292.105824	1	< 0.1%
1103.000191	1	< 0.1%
786.91838	1	< 0.1%
686.986965	1	< 0.1%
653.930338	1	< 0.1%
602.287567	1	< 0.1%
586.555133	1	< 0.1%
537.639051	1	< 0.1%
530.554969	1	< 0.1%
511.780674	1	< 0.1%

offering_amt
Real number (ℝ)

Distinct	73
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	987463.81

Minimum	225000
Maximum	11000000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.2 MiB

Quantile statistics

Minimum	225000
5-th percentile	300000
Q1	500000
median	750000
Q3	1250000
95-th percentile	2250000
Maximum	11000000
Range	10775000
Interquartile range (IQR)	750000

Descriptive statistics

Standard deviation	782226.15
Coefficient of variation (CV)	0.79215678
Kurtosis	40.546021
Mean	987463.81
Median Absolute Deviation (MAD)	250000
Skewness	4.5932382
Sum	1.3084883 × 10¹²
Variance	6.1187775 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
500000	188300	14.2%
1000000	184100	13.9%
750000	147000	11.1%
1500000	84000	6.3%
1250000	81900	6.2%
600000	74200	5.6%
400000	65800	5.0%
300000	46900	3.5%
700000	42000	3.2%
2000000	40600	3.1%
Other values (63)	370300	27.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
225000	700	0.1%
250000	19600	1.5%
275000	2800	0.2%
300000	46900	3.5%
325000	1400	0.1%
350000	37800	2.9%
375000	2100	0.2%
380000	700	0.1%
400000	65800	5.0%
420000	700	0.1%

Value	Count	Frequency (%)
11000000	1400	0.1%
9000000	700	0.1%
7500000	700	0.1%
6000000	2100	0.2%
5500000	700	0.1%
5000000	2100	0.2%
4250000	1400	0.1%
4000000	2800	0.2%
3750000	700	0.1%
3500000	2100	0.2%

offering_price
Real number (ℝ)

Distinct	748
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	99.684888

Minimum	95.273
Maximum	106.94884
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.2 MiB

Quantile statistics

Minimum	95.273
5-th percentile	98.954
Q1	99.59
median	99.808
Q3	99.937
95-th percentile	100
Maximum	106.94884
Range	11.67584
Interquartile range (IQR)	0.347

Descriptive statistics

Standard deviation	0.43945333
Coefficient of variation (CV)	0.0044084248
Kurtosis	55.129404
Mean	99.684888
Median Absolute Deviation (MAD)	0.155
Skewness	-0.36003979
Sum	1.3209245 × 10⁸
Variance	0.19311923
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	158900	12.0%
99.975	7700	0.6%
99.992	7000	0.5%
99.888	6300	0.5%
99.83	6300	0.5%
99.819	6300	0.5%
99.899	5600	0.4%
99.861	5600	0.4%
99.983	5600	0.4%
99.957	5600	0.4%
Other values (738)	1110200	83.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
95.273	700	0.1%
95.291	700	0.1%
95.83	700	0.1%
97.052	700	0.1%
97.541	700	0.1%
97.589	700	0.1%
97.636	700	0.1%
97.698	700	0.1%
97.818	700	0.1%
97.831	700	0.1%

Value	Count	Frequency (%)
106.94884	700	0.1%
100.63342	700	0.1%
100.5	700	0.1%
100	158900	12.0%
99.999	1400	0.1%
99.998	1400	0.1%
99.997	2800	0.2%
99.996	700	0.1%
99.995	4200	0.3%
99.994	4200	0.3%

offering_yield
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1765
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	928.11627

Minimum	1.57296
Maximum	1750000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.2 MiB

Quantile statistics

Minimum	1.57296
5-th percentile	2.26303
Q1	2.98399
median	3.563
Q3	4.17621
95-th percentile	5.4
Maximum	1750000
Range	1749998.4
Interquartile range (IQR)	1.19222

Descriptive statistics

Standard deviation	40211.221
Coefficient of variation (CV)	43.325629
Kurtosis	1888.0077
Mean	928.11627
Median Absolute Deviation (MAD)	0.588
Skewness	43.474185
Sum	1.2298469 × 10⁹
Variance	1.6169423 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.375	6300	0.5%
5.25	6300	0.5%
5	4900	0.4%
5.625	4900	0.4%
5.125	4900	0.4%
6.125	4200	0.3%
4.75	4200	0.3%
5.75	3500	0.3%
5.875	3500	0.3%
4.375	2100	0.2%
Other values (1755)	1280300	96.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.57296	700	0.1%
1.57902	700	0.1%
1.64392	700	0.1%
1.65	700	0.1%
1.695	700	0.1%
1.70503	700	0.1%
1.72201	700	0.1%
1.724	700	0.1%
1.728	700	0.1%
1.73404	700	0.1%

Value	Count	Frequency (%)
1750000	700	0.1%
9	700	0.1%
8.62493	700	0.1%
8.125	700	0.1%
7.75	1400	0.1%
7.7494	700	0.1%
7.625	2100	0.2%
7.5	2100	0.2%
7.375	1400	0.1%
7.25	700	0.1%

principal_amt
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	20.2 MiB

1000.0	1322300
200000.0	2100
0.0	700

Length

Max length	8
Median length	6
Mean length	6.0015848
Min length	3

Characters and Unicode

Total characters	7952700
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1000.0
2nd row	1000.0
3rd row	1000.0
4th row	1000.0
5th row	1000.0

Common Values

Value	Count	Frequency (%)
1000.0	1322300	99.8%
200000.0	2100	0.2%
0.0	700	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1000.0	1322300	99.8%
200000.0	2100	0.2%
0.0	700	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	5303200	66.7%
.	1325100	16.7%
1	1322300	16.6%
2	2100	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6627600	83.3%
Other Punctuation	1325100	16.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5303200	80.0%
1	1322300	20.0%
2	2100	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	1325100	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	7952700	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5303200	66.7%
.	1325100	16.7%
1	1322300	16.6%
2	2100	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7952700	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5303200	66.7%
.	1325100	16.7%
1	1322300	16.6%
2	2100	< 0.1%

coupon
Real number (ℝ)

Distinct	247
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.6221865

Minimum	1.55
Maximum	8.75
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.2 MiB

Quantile statistics

Minimum	1.55
5-th percentile	2.25
Q1	2.95
median	3.5
Q3	4.125
95-th percentile	5.375
Maximum	8.75
Range	7.2
Interquartile range (IQR)	1.175

Descriptive statistics

Standard deviation	0.99403283
Coefficient of variation (CV)	0.27442895
Kurtosis	2.2077077
Mean	3.6221865
Median Absolute Deviation (MAD)	0.6
Skewness	1.0279602
Sum	4799759.3
Variance	0.98810127
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.5	55300	4.2%
4	43400	3.3%
3.25	38500	2.9%
3	32200	2.4%
3.75	32200	2.4%
3.375	30100	2.3%
3.2	28000	2.1%
3.8	27300	2.1%
2.75	26600	2.0%
3.4	25900	2.0%
Other values (237)	985600	74.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.55	1400	0.1%
1.625	1400	0.1%
1.65	700	0.1%
1.7	4900	0.4%
1.75	1400	0.1%
1.8	2800	0.2%
1.85	4900	0.4%
1.875	3500	0.3%
1.9	2100	0.2%
1.902	700	0.1%

Value	Count	Frequency (%)
8.75	700	0.1%
8.375	700	0.1%
7.95	700	0.1%
7.75	1400	0.1%
7.625	2100	0.2%
7.5	3500	0.3%
7.375	2100	0.2%
7.25	700	0.1%
7.125	700	0.1%
7	1400	0.1%

offering_year
Real number (ℝ)

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2015.8452

Minimum	2012
Maximum	2019
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.2 MiB

Quantile statistics

Minimum	2012
5-th percentile	2012
Q1	2014
median	2016
Q3	2017
95-th percentile	2019
Maximum	2019
Range	7
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.1006949
Coefficient of variation (CV)	0.0010420914
Kurtosis	-0.93674086
Mean	2015.8452
Median Absolute Deviation (MAD)	2
Skewness	-0.2821349
Sum	2.6711965 × 10⁹
Variance	4.4129189
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2017	252000	19.0%
2016	228200	17.2%
2018	173600	13.1%
2015	149800	11.3%
2019	147000	11.1%
2014	142800	10.8%
2013	116900	8.8%
2012	114800	8.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2012	114800	8.7%
2013	116900	8.8%
2014	142800	10.8%
2015	149800	11.3%
2016	228200	17.2%
2017	252000	19.0%
2018	173600	13.1%
2019	147000	11.1%

Value	Count	Frequency (%)
2019	147000	11.1%
2018	173600	13.1%
2017	252000	19.0%
2016	228200	17.2%
2015	149800	11.3%
2014	142800	10.8%
2013	116900	8.8%
2012	114800	8.7%

offering_month
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.3454834

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.3376678
Coefficient of variation (CV)	0.5259911
Kurtosis	-1.2554025
Mean	6.3454834
Median Absolute Deviation (MAD)	3
Skewness	0.036246801
Sum	8408400
Variance	11.140026
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
11	151900	11.5%
3	151900	11.5%
5	147700	11.1%
9	142800	10.8%
2	129500	9.8%
8	115500	8.7%
6	102900	7.8%
1	84700	6.4%
7	84000	6.3%
10	81900	6.2%
Other values (2)	132300	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	84700	6.4%
2	129500	9.8%
3	151900	11.5%
4	77700	5.9%
5	147700	11.1%
6	102900	7.8%
7	84000	6.3%
8	115500	8.7%
9	142800	10.8%
10	81900	6.2%

Value	Count	Frequency (%)
12	54600	4.1%
11	151900	11.5%
10	81900	6.2%
9	142800	10.8%
8	115500	8.7%
7	84000	6.3%
6	102900	7.8%
5	147700	11.1%
4	77700	5.9%
3	151900	11.5%

maturity_year
Real number (ℝ)

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2024.859

Minimum	2019
Maximum	2039
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.2 MiB

Quantile statistics

Minimum	2019
5-th percentile	2021
Q1	2022
median	2024
Q3	2027
95-th percentile	2029
Maximum	2039
Range	20
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.42016
Coefficient of variation (CV)	0.0016890856
Kurtosis	3.3712725
Mean	2024.859
Median Absolute Deviation (MAD)	2
Skewness	1.4922031
Sum	2.6831406 × 10⁹
Variance	11.697495
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
2023	194600	14.7%
2022	192500	14.5%
2024	180600	13.6%
2026	137900	10.4%
2027	123900	9.4%
2025	122500	9.2%
2021	91000	6.9%
2028	90300	6.8%
2029	72100	5.4%
2020	51800	3.9%
Other values (11)	67900	5.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2019	4200	0.3%
2020	51800	3.9%
2021	91000	6.9%
2022	192500	14.5%
2023	194600	14.7%
2024	180600	13.6%
2025	122500	9.2%
2026	137900	10.4%
2027	123900	9.4%
2028	90300	6.8%

Value	Count	Frequency (%)
2039	6300	0.5%
2038	11900	0.9%
2037	4900	0.4%
2036	7700	0.6%
2035	12600	1.0%
2034	9800	0.7%
2033	2800	0.2%
2032	700	0.1%
2031	700	0.1%
2030	6300	0.5%

maturity_month
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.1674591

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.3755852
Coefficient of variation (CV)	0.54732187
Kurtosis	-1.1993941
Mean	6.1674591
Median Absolute Deviation (MAD)	3
Skewness	0.18354206
Sum	8172500
Variance	11.394576
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
3	198100	14.9%
5	127400	9.6%
6	118300	8.9%
11	118300	8.9%
8	109200	8.2%
9	102900	7.8%
4	101500	7.7%
2	100800	7.6%
1	98000	7.4%
10	84700	6.4%
Other values (2)	165900	12.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	98000	7.4%
2	100800	7.6%
3	198100	14.9%
4	101500	7.7%
5	127400	9.6%
6	118300	8.9%
7	82600	6.2%
8	109200	8.2%
9	102900	7.8%
10	84700	6.4%

Value	Count	Frequency (%)
12	83300	6.3%
11	118300	8.9%
10	84700	6.4%
9	102900	7.8%
8	109200	8.2%
7	82600	6.2%
6	118300	8.9%
5	127400	9.6%
4	101500	7.7%
3	198100	14.9%

Auto

Heatmap
Table

	entrd_vol_qt	rptd_pr	yld_pt	offering_amt	offering_price	offering_yield	coupon	offering_year	offering_month	maturity_year	maturity_month	principal_amt
entrd_vol_qt	1.000	-0.014	0.055	0.334	0.057	0.002	0.004	0.150	-0.048	0.044	-0.057	0.000
rptd_pr	-0.014	1.000	-0.506	0.103	-0.055	0.344	0.350	0.143	-0.058	0.411	-0.023	0.008
yld_pt	0.055	-0.506	1.000	-0.166	0.003	0.366	0.365	0.087	-0.000	0.245	-0.010	0.000
offering_amt	0.334	0.103	-0.166	1.000	0.095	-0.179	-0.174	0.119	-0.097	0.006	-0.101	0.041
offering_price	0.057	-0.055	0.003	0.095	1.000	-0.036	-0.003	0.123	-0.026	-0.139	-0.053	0.030
offering_yield	0.002	0.344	0.366	-0.179	-0.036	1.000	0.989	0.036	-0.053	0.418	-0.022	0.000
coupon	0.004	0.350	0.365	-0.174	-0.003	0.989	1.000	0.035	-0.052	0.420	-0.025	0.038
offering_year	0.150	0.143	0.087	0.119	0.123	0.036	0.035	1.000	-0.191	0.489	-0.166	0.067
offering_month	-0.048	-0.058	-0.000	-0.097	-0.026	-0.053	-0.052	-0.191	1.000	-0.092	0.705	0.104
maturity_year	0.044	0.411	0.245	0.006	-0.139	0.418	0.420	0.489	-0.092	1.000	-0.102	0.045
maturity_month	-0.057	-0.023	-0.010	-0.101	-0.053	-0.022	-0.025	-0.166	0.705	-0.102	1.000	0.083
principal_amt	0.000	0.008	0.000	0.041	0.030	0.000	0.038	0.067	0.104	0.045	0.083	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	cusip_id	trd_exctn_dt	bond_sym_id	company_symbol	entrd_vol_qt	rptd_pr	yld_pt	offering_amt	offering_price	offering_yield	principal_amt	coupon	offering_year	offering_month	maturity_year	maturity_month
0	00037BAB8	2019-03-20	ABB3852125	ABB	75000.0	99.96200	2.887133	1250000.0	97.833	3.12905	1000.0	2.875	2012	5	2022	5
1	00037BAB8	2019-03-21	ABB3852125	ABB	1305000.0	100.36900	2.750151	1250000.0	97.833	3.12905	1000.0	2.875	2012	5	2022	5
2	00037BAB8	2019-03-22	ABB3852125	ABB	1170000.0	100.30700	2.770905	1250000.0	97.833	3.12905	1000.0	2.875	2012	5	2022	5
3	00037BAB8	2019-03-25	ABB3852125	ABB	600000.0	100.78626	2.609905	1250000.0	97.833	3.12905	1000.0	2.875	2012	5	2022	5
4	00037BAB8	2019-03-26	ABB3852125	ABB	100000.0	100.66900	2.649010	1250000.0	97.833	3.12905	1000.0	2.875	2012	5	2022	5
5	00037BAB8	2019-03-27	ABB3852125	ABB	100000.0	101.11000	2.501097	1250000.0	97.833	3.12905	1000.0	2.875	2012	5	2022	5
6	00037BAB8	2019-03-28	ABB3852125	ABB	1535000.0	100.77700	2.612148	1250000.0	97.833	3.12905	1000.0	2.875	2012	5	2022	5
7	00037BAB8	2019-03-29	ABB3852125	ABB	1459000.0	100.76800	2.614960	1250000.0	97.833	3.12905	1000.0	2.875	2012	5	2022	5
8	00037BAB8	2019-04-01	ABB3852125	ABB	32000.0	100.50900	2.702067	1250000.0	97.833	3.12905	1000.0	2.875	2012	5	2022	5
9	00037BAB8	2019-04-02	ABB3852125	ABB	360000.0	100.78400	2.609145	1250000.0	97.833	3.12905	1000.0	2.875	2012	5	2022	5

	cusip_id	trd_exctn_dt	bond_sym_id	company_symbol	entrd_vol_qt	rptd_pr	yld_pt	offering_amt	offering_price	offering_yield	principal_amt	coupon	offering_year	offering_month	maturity_year	maturity_month
1345390	98978VAN3	2022-08-18	PFE4666688	PFE	50000.0	99.69000	3.958561	500000.0	99.811	3.92303	1000.0	3.9	2018	8	2028	8
1345391	98978VAN3	2022-08-22	PFE4666688	PFE	29000.0	98.47800	4.189910	500000.0	99.811	3.92303	1000.0	3.9	2018	8	2028	8
1345392	98978VAN3	2022-08-23	PFE4666688	PFE	200000.0	98.23900	4.236037	500000.0	99.811	3.92303	1000.0	3.9	2018	8	2028	8
1345393	98978VAN3	2022-08-24	PFE4666688	PFE	1000000.0	98.56200	4.173956	500000.0	99.811	3.92303	1000.0	3.9	2018	8	2028	8
1345394	98978VAN3	2022-08-25	PFE4666688	PFE	525000.0	98.39205	4.206974	500000.0	99.811	3.92303	1000.0	3.9	2018	8	2028	8
1345395	98978VAN3	2022-08-26	PFE4666688	PFE	210000.0	98.38700	4.208056	500000.0	99.811	3.92303	1000.0	3.9	2018	8	2028	8
1345396	98978VAN3	2022-08-29	PFE4666688	PFE	1500000.0	98.03600	4.276044	500000.0	99.811	3.92303	1000.0	3.9	2018	8	2028	8
1345397	98978VAN3	2022-08-30	PFE4666688	PFE	125000.0	98.04100	4.275075	500000.0	99.811	3.92303	1000.0	3.9	2018	8	2028	8
1345398	98978VAN3	2022-08-31	PFE4666688	PFE	480000.0	97.87200	4.308006	500000.0	99.811	3.92303	1000.0	3.9	2018	8	2028	8
1345399	98978VAN3	2022-09-01	PFE4666688	PFE	400000.0	97.14800	4.450082	500000.0	99.811	3.92303	1000.0	3.9	2018	8	2028	8

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample